Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
StandardParcelSizeID (PK) | Token identifier for a CarrierStandardParcelSize entity type instance | ID_STD_PRCL_SZ | Identity | integer | |
CarrierID (FK) | A unique system assigned identifier for the Carrier. | ID_CRR | Identity | integer | Carrier(PA_CRR) |
ParcelStandardSizeCode | A carrier-specific code that designates a standard size and accompanying pricing for transporting a package. Examples: Federal Express 01 - FedEx Customer Packaging 02 - FedEx Pak 03 - FedEx Box 04 - FedEx Tube 08 - FedEx Packet (select markets) UPS 10 or 22 10kg or 22 lbs. box 25 or 55 25kg or 55 lbs. box US Postal Service FLT - Flat LTP or 06 - Priority mail letter pack LTR or 06 - Letter FSB - Priority Mail Small Flat Rate Box FRB - Priority Mail (Regular) Flat Rate Box IRG - Irregular Parcel Other carriers will have their own codes | CD_PRCL_STD_SZ | Code | varchar(20) | |
GrossWeightQuantity | The gross weight of the ShipmentContainer including merchandise plus the weight of the container itself | QW_GS_WT_QTY | Quantity | DECIMAL(9,3) | |
DimensionalWeightQuantity | Dimensional weight, also known as volumetric weight, is a pricing technique for commercial freight transport (including courier and postal services), which uses an estimated weight that is calculated from the length, width and height of a package. Shipping costs have historically been calculated on the basis of gross weight in kilograms or pounds. By charging only by weight, lightweight, low density packages become unprofitable for freight carriers due to the amount of space they take up in the truck/aircraft/ship in proportion to their actual weight. The concept of dimensional weight has been adopted by the transportation industry worldwide as a uniform means of establishing a minimum charge for the cubic space a package occupies. In fact, UPS[1] and Fedex[2] have recently announced that starting 2015, shipping charges on all shipments (air and ground) will be determined by greater of the actual weight and dimensional weight of a package. Prior to this announcement, dimensional weight charges were only applicable to packages of a specific size range. Dimensional weight is a calculation of a theoretical weight of a package. This theoretical weight is the weight of the package at a minimum density chosen by the freight carrier. If the package is below this minimum density, then the actual weight is irrelevant as the freight carrier will charge for the volume of the package as if it were of the chosen density (what the package would weigh at the minimum density). Furthermore, the volume used to calculate the dimensional weight may not be absolutely representative of the true volume of the package. The freight carrier will measure the longest dimension in each of the three axis (X, Y, Z) and use these measurements to determine the package volume. If the package is a right-angled rectangular box (cuboid), then this will be equal to the true volume of the package. However, if the package is of any other shape, then the calculation of volume will be more than the true volume of the package. Dimensional weight is also known as DIM weight, volumetric weight, or cubed weight. Freight carriers utilize the greater of the actual weight or dimensional weight to calculate shipping charges. Dimensional weight is calculated as (length � width � height) / (dimensional factor). Measurements can be made all in inches or all in centimeters, but the appropriate shipping factor must also be used. | QW_DMNSNL_WT_QTY | Quantity | DECIMAL(9,3) | |
WeightQuantity | The weight of the merchandise without the container. | QW_WT_QTY | Quantity | DECIMAL(9,3) | |
Weight (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_UOM_WT | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
ContainerHeightQuantity | The height of a container. Used to define dimensions for load configuration. | QL_CNR_HT_QTY | Quantity | DECIMAL(9,3) | |
ContainerLengthQuantity | The length of a container. Used to define dimensions for load configuration. | QL_CNR_LNG_QTY | Quantity | DECIMAL(9,3) | |
ContainerWidthQuantity | The width of a container. Used to define dimensions for load configuration. | QL_CNR_WD_QTY | Quantity | DECIMAL(9,3) | |
Linear (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_UOM_LNR | Code | varchar(20) | UnitOfMeasure(CO_UOM) |